www.loanperformer.com

Table of Contents (Online Help)

Group Member Arrears Report

The Group Member Arrears report gives details of those loans whose loan repayments fell due and have not been paid to the selected reporting date. 

How to access the Group Member Arrears Report

To access this report, go to Loans/Portfolio Reports/Group Members Portfolio Reports/Group Member Arrears Report and the following screen appears:

• Reporting date: Enter the date from which the report on Group Member Arrears report is to start.  It will be inclusive of the date selected e.g. 30/11/2017 as seen in the screen above. The system usually defaults to the last end of month date you can then change to the appropriate date.
• From Loan No:  Enter the loan number for which the Amount per Group Member report should start e.g. KA/00014 and in the "To" section enter the loan number for which the report will stop e.g. KA/00014 as seen in the screen above. This will show all Loan amounts that are in arrears by each member as at that given date.
• Report currency: From the drop down list select the currency in which the report will appear, e.g., "UGX".
• Check for all:  When this option is selected, then the Group Member Arrears report will show all the loan amounts that were taken by all group members for as at that date.   
• Branch Code: Select a branch for which you want to generate a report. In the example above, we have checked "For all" option to have Amount per Group Member report for all branches.
• Credit Officer:  Select from the drop down box a particular Credit Officer whom you want to generate a group member arrears report. In the example, the "For all" option is checked, this is in order to have a report on all group member arrears report for all Credit Officers.
• Loan Fund: From the drop down box, select a particular Loan Fund that you want to generate the group member arrears report i.e. to know the performance of a particular loan fund. The Loan Fund is set at Menu System/Configuration/Funds. In the example, the "For all" option is checked.
• Geographical Area: From the drop down box, you can select to generate Amounts per Group Member report basing on the actual locations of the clients. For example Districts, County, Sub-County and Parish as specified in your settings under Menu Support Files/Geographical Area's. In the example in the first screen of this page, the "For all" option is selected in order to have an group member arrears report for members from all geographical areas.
• Loan Product: From the drop down box, select a loan Product that you want to generate a report about. The Loan product depends on what was set at Menu System/Configuration/Products. You may have Loan Products like School Fees Loans, Agricultural Loans etc. In the example above, the "For all" option is selected in order to have group member arrears report for all Loan Products.
• Business Sector: From the drop down box, select a business sector for which you want to generate the group member arrears report. This can be Agriculture, Industry, Services or any other depending on what you set at Menu Support files/Business Sector. In the example above, the "For all" option is selected to have a Loan Amounts per Group Member report for all business sectors in the selected period.
• Cost centre: Choose a specific cost centre that you want to be reported on from the drop-down or tick the Check for all option to include all cost centres.
• Grouping/Order: Select from the drop down box how the report to be generated will be classified i.e. in the column title/heading. In the first screen on this page, Group by Client Name is selected.
• Report Format: Select from the drop down box the sequence in which the column titles in the Loan Amounts per Group Member report will appear.  In the first screen on this page, the first option is selected.
• Member Category 1:  Select a particular category of group members from the drop down box or check "For All" option to have Loan Amounts per Group Member report for all the categories of group members available in the system.  Member Category is set at menu Support Files/Group Member Category 1. This applies to member category 2 and 3.

• Client Category 1: From the drop down box, select a client based on the classification that you made at Menu Support Files Client Category 1. In the example, the "For all" option is checked. The same applies for Client Category 2 and client Category 3.
• Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.
• Member Loan Category 1: From the drop down box, select a classification of a loan that you made at Menu Support Files/Loan Category 1, it may have been a long term loan, short term loan etc. In the example, the "For all" option is checked. The same applies for Loan Category 2 and Loan Category 3.

Click on the OK command button to generate the report which will look like one below:

• Additional filtering options? : This option is used to get a particular field or specification that you want. It helps you to narrow down the search for information that you need. When you check this option and click ok, a pop up screen will appear. 

• In the pop up screen, select the required filter criteria from the drop down boxes e.g. LAMOUNT, relational operator e.g. "=" (Equals sign) and the value e.g. 400,000. Then by PRINCIPAL = 266,666.68
• Click the OK button if all the data entered is sufficient. You will get another pop up information screen showing the filter for the Loan Status report that was selected.  Click on "Yes" button if it is the right filter to generate the Loan Status report.

• When the additional filter option is not selected, we will continue with the details in the first screen and it will be as follows:

Contact LPF live support for more information
This service requires an Internet connection.